/*河南星辰软件科技有限公司
@copyright Copyright (c) 2010~2022 All rights reserved.
*/
package cn.javaxc.psi.action.supplychainmana;
import java.io.*;
import java.util.*;
import java.sql.*;
import cn.javaxc.model.base.SQL;
import cn.javaxc.model.base.SQLList;
import cn.javaxc.model.base.SQLMap;
import cn.javaxc.model.base.SQLParam;
import cn.javaxc.model.page.BatisPage;
import cn.javaxc.mvcwork.controller.web.TreeBean;
import cn.javaxc.mvcwork.util.common.CommonUtil;
import cn.javaxc.mvcwork.util.common.MapListUtil;
import cn.javaxc.mvcwork.util.helper.FrameHelper;
import cn.javaxc.mvcwork.util.helper.TreeTableHelper;
import org.springframework.beans.factory.annotation.Autowired;
import cn.javaxc.system.action.base.BaseAction;
import cn.javaxc.psi.mapper.supplychainmana.ProcureSupplyMapper;
public class ProcureSupplyAction extends BaseAction
{
    @Autowired(required=false)
	private ProcureSupplyMapper mapper;
    /**
    统计图
    */
    
    public Map procurementChartSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        super.listDepartments();
        
        
        result.put("s_search", pagination.getSearchParas());
        
        
        SQLList<SQLMap> all=mapper.all(params);
        result.put("all", all);
        
        return result;
    }
    /**
    */
    
    public Object s_task() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_task=mapper.s_task(params,pagination);
        s_task.setPagedListInfo(pagination);
        result.put("s_task", s_task);
        
        return s_task;
    }
    /**
    饼状统计图
    */
    
    public Map procurementPancake() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> s_c=mapper.s_c(params);
        result.put("s_c", s_c);
        
        return result;
    }
    /**
    任务详情
    */
    
    public Map procurementDet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_task=mapper.t_task(params);
        SQLMap t_task_emt=t_task.getExistfirst();
        result.put("t_task", t_task_emt);
        
        return result;
    }
    /**
    任务完成
    */
    
    public Map procurementOverSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_task=mapper.t_task(params);
        SQLMap t_task_emt=t_task.getExistfirst();
        result.put("t_task", t_task_emt);
        
        return result;
    }
    /**
    采购批次
    */
    
    public Map purchaseBatchSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_pro=mapper.s_pro(params);
        result.put("s_pro", s_pro);
        
        
        SQLList<SQLMap> t_pro=mapper.t_pro(params);
        SQLMap t_pro_emt=t_pro.getExistfirst();
        result.put("t_pro", t_pro_emt);
        
        return result;
    }
    /**
    供应商
    */
    
    public Map supplierProcurement() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_info=mapper.s_info(params);
        result.put("s_info", s_info);
        
        return result;
    }
    /**
    供应商详情
    */
    
    public Map supplierDetProcurment() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> message=mapper.message(params);
        SQLMap message_emt=message.getExistfirst();
        result.put("message", message_emt);
        
        return result;
    }
    /**
    附属信息
    */
    
    public Map subsidiaryInformation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_client_cert=mapper.s_client_cert(params);
        result.put("s_client_cert", s_client_cert);
        
        
        SQLList<SQLMap> s_file_version=mapper.s_file_version(params);
        result.put("s_file_version", s_file_version);
        
        
        SQLList<SQLMap> s_quality=mapper.s_quality(params);
        result.put("s_quality", s_quality);
        
        
        SQLList<SQLMap> s_bank_account=mapper.s_bank_account(params);
        result.put("s_bank_account", s_bank_account);
        
        return result;
    }
    /**
    工厂调查
    */
    
    public Map factorySurveysSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_sur=mapper.s_sur(params);
        result.put("s_sur", s_sur);
        
        return result;
    }
    /**
    业绩评价
    */
    
    public Map performanceEvaluation() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_evaluate=mapper.s_evaluate(params);
        result.put("s_evaluate", s_evaluate);
        
        return result;
    }
    /**
    采购合同
    */
    
    public Map procurementContractSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_price=mapper.s_price(params);
        result.put("s_price", s_price);
        
        return result;
    }
    /**
    合同详情
    */
    
    public Map contractSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> produce=mapper.produce(params);
        result.put("produce", produce);
        
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        
        SQLList<SQLMap> s_num=mapper.s_num(params);
        SQLMap s_num_emt=s_num.getExistfirst();
        result.put("s_num", s_num_emt);
        
        return result;
    }
    /**
    采购合同
    */
    
    public Map procurementContractS() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_task=mapper.t_task(params);
        SQLMap t_task_emt=t_task.getExistfirst();
        result.put("t_task", t_task_emt);
        
        
        SQLList<SQLMap> s_price=mapper.s_price(params);
        result.put("s_price", s_price);
        
        return result;
    }
    /**
    合同增加页面
    */
    
    public Map contractAddPage() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_top=mapper.s_top(params);
        result.put("s_top", s_top);
        
        return result;
    }
    /**
    付款账号选择
    */
    
    public Map paymentSelection() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_bank_account=mapper.s_bank_account(params);
        result.put("s_bank_account", s_bank_account);
        
        return result;
    }
    /**
    增加采购合同
    */
    
    public Map addProcurementContract() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> cmessg=mapper.cmessg(params);
        result.put("cmessg", cmessg);
        
        
        SQLList<SQLMap> s_predict=mapper.s_predict(params);
        result.put("s_predict", s_predict);
        
        
        result.put("s_ecode", create_code(12,"bar"));
        
        
        SQLList<SQLMap> person=mapper.person(params);
        result.put("person", person);
        
        
        SQLList<SQLMap> lct=mapper.lct(params);
        result.put("lct", lct);
        
        return result;
    }
    /**
    选择供应商
    */
    
    public Map selectionSuppliers() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> p_messg=mapper.p_messg(params,pagination);
        p_messg.setPagedListInfo(pagination);
        result.put("p_messg", p_messg);
        
        
        result.put("s_search", pagination.getSearchParas());
        
        return result;
    }
    /**
    选择联系人
    */
    
    public Map chooseContacts() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> person=mapper.person(params);
        result.put("person", person);
        
        return result;
    }
    /**
    合同管理
    */
    
    public Map contractManagement() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> produce=mapper.produce(params);
        result.put("produce", produce);
        
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        
        SQLList<SQLMap> s_num=mapper.s_num(params);
        SQLMap s_num_emt=s_num.getExistfirst();
        result.put("s_num", s_num_emt);
        
        return result;
    }
    /**
    合同详情
    */
    
    public Map contractDetails() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        return result;
    }
    /**
    合同明细页面
    */
    
    public Map publicContractdet() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        return result;
    }
    /**
    产品选择
    */
    
    public Map productSelection() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> s_product=mapper.s_product(params);
        result.put("s_product", s_product);
        
        
        Object pro_price =mapper.pro_price(params);
        result.put("pro_price", pro_price);
        
        
        SQLList<SQLMap> s_price=mapper.s_price(params);
        SQLMap s_price_emt=s_price.getExistfirst();
        result.put("s_price", s_price_emt);
        
        
        SQLList<SQLMap> s_pose=mapper.s_pose(params);
        SQLMap s_pose_emt=s_pose.getExistfirst();
        result.put("s_pose", s_pose_emt);
        
        return result;
    }
    /**
    修改产品
    */
    
    public Map modifyProductSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        SQLList<SQLMap> t_product=mapper.t_product(params);
        SQLMap t_product_emt=t_product.getExistfirst();
        result.put("t_product", t_product_emt);
        
        return result;
    }
    /**
    责任选择
    */
    
    public Map responsibilityChoice() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_demand1=mapper.s_demand1(params);
        result.put("s_demand1", s_demand1);
        
        return result;
    }
    /**
    修改责任
    */
    
    public Map upResponsibility() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        SQLMap s_duty_emt=s_duty.getExistfirst();
        result.put("s_duty", s_duty_emt);
        
        return result;
    }
    /**
    付款方式
    */
    
    public Map paymentMethodSupps() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_pay_client=mapper.t_pay_client(params);
        SQLMap t_pay_client_emt=t_pay_client.getExistfirst();
        result.put("t_pay_client", t_pay_client_emt);
        
        return result;
    }
    /**
    付款账号选择
    */
    
    public Map selectionPaymentSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_bank_account=mapper.s_bank_account(params);
        result.put("s_bank_account", s_bank_account);
        
        return result;
    }
    /**
    增加银行账号
    */
    
    public Map increaseBankSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        return result;
    }
    /**
    修改银行账户
    */
    
    public Map upIncreaseBankSupply() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> t_bank=mapper.t_bank(params);
        SQLMap t_bank_emt=t_bank.getExistfirst();
        result.put("t_bank", t_bank_emt);
        
        return result;
    }
    /**
    违约责任
    */
    
    public Map liabilityContract() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_lbreakduty=mapper.s_lbreakduty(params);
        result.put("s_lbreakduty", s_lbreakduty);
        
        
        
        return result;
    }
    /**
    修改违约责任
    */
    
    public Map modifyLiabilityContract() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        SQLMap s_breakduty_emt=s_breakduty.getExistfirst();
        result.put("s_breakduty", s_breakduty_emt);
        
        return result;
    }
    /**
    其他要求
    */
    
    public Map otherRequireAdd() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        
        return result;
    }
    /**
    修改其他要求
    */
    
    public Map modifOtherRequire() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        SQLMap s_demand_emt=s_demand.getExistfirst();
        result.put("s_demand", s_demand_emt);
        
        return result;
    }
    /**
    修改合同
    */
    
    public Map amendmentContract() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> quo=mapper.quo(params);
        SQLMap quo_emt=quo.getExistfirst();
        result.put("quo", quo_emt);
        
        return result;
    }
    /**
    合同修改页面
    */
    
    public Map publicContractUp() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> price=mapper.price(params);
        result.put("price", price);
        
        
        SQLList<SQLMap> pum=mapper.pum(params);
        result.put("pum", pum);
        
        
        SQLList<SQLMap> s_demand=mapper.s_demand(params);
        result.put("s_demand", s_demand);
        
        
        SQLList<SQLMap> s_bank=mapper.s_bank(params);
        result.put("s_bank", s_bank);
        
        
        SQLList<SQLMap> s_breakduty=mapper.s_breakduty(params);
        result.put("s_breakduty", s_breakduty);
        
        
        SQLList<SQLMap> s_pay=mapper.s_pay(params);
        result.put("s_pay", s_pay);
        
        
        SQLList<SQLMap> s_duty=mapper.s_duty(params);
        result.put("s_duty", s_duty);
        
        return result;
    }
    /**
    采购周期
    */
    
    public Map purchaseList() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_procurement_cycle=mapper.s_procurement_cycle(params,pagination);
        s_procurement_cycle.setPagedListInfo(pagination);
        result.put("s_procurement_cycle", s_procurement_cycle);
        
        return result;
    }
    /**
    设置采购周期
    */
    
    public Map purchaseDetile() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        SQLList<SQLMap> s_product_info=mapper.s_product_info(params);
        SQLMap s_product_info_emt=s_product_info.getExistfirst();
        result.put("s_product_info", s_product_info_emt);
        
        return result;
    }
    /**
    */
    
    public Map d_task() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_task(params);
        
        return result;
    }
    /**
    任务完成修改
    */
    
    public Map procurementOverSupplySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.procurementOverSupplySubmit(params);
        
        return result;
    }
    /**
    */
    
    public Map d_quality() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_quality(params);
        
        return result;
    }
    /**
    */
    
    public Map d_bank_account() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_bank_account(params);
        
        return result;
    }
    /**
    */
    
    public Map d_sur() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_sur(params);
        
        return result;
    }
    /**
    */
    
    public Map d_evaluate() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_evaluate(params);
        
        return result;
    }
    /**
    */
    
    public Map d_contract() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_contract(params);
        
        return result;
    }
    /**
    */
    
    public Map exe_price() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.exe_price(params);
        
        return result;
    }
    /**
    */
    
    public Map com_price() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.com_price(params);
        
        return result;
    }
    /**
    */
    
    public Map d_price() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_price(params);
        
        return result;
    }
    /**
    合同增加页面修改
    */
    
    public Map contractAddPageSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("quo_producenum")){
            params=new SQLParam(request,emt.getMap());
            mapper.producenum_id(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("duty")){
            params=new SQLParam(request,emt.getMap());
            mapper.duty_id(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("pay_client")){
            params=new SQLParam(request,emt.getMap());
            mapper.pay_id(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("bank")){
            params=new SQLParam(request,emt.getMap());
            mapper.bank_id(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("breakduty")){
            params=new SQLParam(request,emt.getMap());
            mapper.breakduty_id(params);
        }
        
        
        for (SQLMap emt:hqlBean.getTableElements("demand")){
            params=new SQLParam(request,emt.getMap());
            mapper.demand_id(params);
        }
        
        return result;
    }
    /**
    增加采购合同修改
    */
    
    public Map addProcurementContractSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID1 = mapper.CMID1(params);
        result.put("CMID1", CMID1);
        
        
        
        return result;
    }
    /**
    */
    
    public Map d_producenum() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_producenum(params);
        
        return result;
    }
    /**
    */
    
    public Map d_bank() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_bank(params);
        
        return result;
    }
    /**
    */
    
    public Map d_duty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_duty(params);
        
        return result;
    }
    /**
    */
    
    public Map d_pay() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_pay(params);
        
        return result;
    }
    /**
    */
    
    public Map d_breakduty() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_breakduty(params);
        
        return result;
    }
    /**
    */
    
    public Map d_demand() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.d_demand(params);
        
        return result;
    }
    /**
    */
    
    public Map c_pirce() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        mapper.c_pirce(params);
        
        return result;
    }
    /**
    产品选择修改
    */
    
    public Map productSelectionSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("quo_producenum")){
            params=new SQLParam(request,emt.getMap());
            mapper.u_product(params);
        }
        
        return result;
    }
    /**
    修改产品修改
    */
    
    public Map modifyProductSupplySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_product = mapper.u_product(params);
        result.put("u_product", u_product);
        
        return result;
    }
    /**
    责任选择修改
    */
    
    public Map responsibilityChoiceSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        for (SQLMap emt:hqlBean.getTableElements("duty")){
            params=new SQLParam(request,emt.getMap());
            mapper.i_demand(params);
        }
        
        return result;
    }
    /**
    修改责任修改
    */
    
    public Map upResponsibilitySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID1 = mapper.CMID1(params);
        result.put("CMID1", CMID1);
        
        return result;
    }
    /**
    付款方式修改
    */
    
    public Map paymentMethodSuppSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int pay = mapper.pay(params);
        result.put("pay", pay);
        
        return result;
    }
    /**
    付款方式修改
    */
    
    public Map paymentMethodSuppsSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int pay = mapper.pay(params);
        result.put("pay", pay);
        
        return result;
    }
    /**
    付款账号选择修改
    */
    
    public Map selectionPaymentSupplySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        for (SQLMap emt:hqlBean.getTableElements("bank")){
            params=new SQLParam(request,emt.getMap());
            mapper.i_bank(params);
        }
        
        return result;
    }
    /**
    增加银行账号修改
    */
    
    public Map increaseBankSupplySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_bank = mapper.u_bank(params);
        result.put("u_bank", u_bank);
        
        return result;
    }
    /**
    修改银行账户修改
    */
    
    public Map upIncreaseBankSupplySubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_bank = mapper.u_bank(params);
        result.put("u_bank", u_bank);
        
        return result;
    }
    /**
    违约责任修改
    */
    
    public Map liabilityContractSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        for (SQLMap emt:hqlBean.getTableElements("breakduty")){
            params=new SQLParam(request,emt.getMap());
            mapper.i_demand(params);
        }
        
        return result;
    }
    /**
    修改违约责任修改
    */
    
    public Map modifyLiabilityContractSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID1 = mapper.CMID1(params);
        result.put("CMID1", CMID1);
        
        return result;
    }
    /**
    其他要求修改
    */
    
    public Map otherRequireAddSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        
        
        for (SQLMap emt:hqlBean.getTableElements("demand")){
            params=new SQLParam(request,emt.getMap());
            mapper.i_demand(params);
        }
        
        return result;
    }
    /**
    修改其他要求修改
    */
    
    public Map modifOtherRequireSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMID1 = mapper.CMID1(params);
        result.put("CMID1", CMID1);
        
        return result;
    }
    /**
    修改合同修改
    */
    
    public Map amendmentContractSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int u_quo = mapper.u_quo(params);
        result.put("u_quo", u_quo);
        
        return result;
    }
    /**
    设置采购周期修改
    */
    
    public Map purchaseDetileSubmit() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int i_procurement_cycle = mapper.i_procurement_cycle(params);
        result.put("i_procurement_cycle", i_procurement_cycle);
        
        return result;
    }
    /**
    */
    
    public Map i_pro() {
        
        Map result=new HashMap();
        SQLParam params=new SQLParam(request,result);
        
        int CMIDpro_id = mapper.CMIDpro_id(params);
        result.put("CMIDpro_id", CMIDpro_id);
        
        
        Object cnt_plan =
        mapper.cnt_plan(params);
        result.put("cnt_plan", cnt_plan);
        
        
        mapper.i_pro(params);
        
        return result;
    }
}